Bromley's Tuxedo Rental Cash Flow Analysis | |||||||
Start Up | November | December | January | February | March | April | |
Cash On Hand | $ 85,000.00 | $ 85,000.00 | $ 88,931.76 | $ 57,870.08 | $ 116,815.02 | $ 85,766.64 | $ 99,725.02 |
Cash Receipts | |||||||
Cash Sales | $ 35,000.00 | $ - | $ 30,000.00 | $ - | $ - | $ - | |
Cash From Receivables | $ 60,000.00 | $ 45,000.00 | $ 50,000.00 | ||||
Salary Income VEC | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | |
Loan | $ 150,800.00 | ||||||
Total Cash Receipts | $ 150,800.00 | $ 118,328.00 | $ 83,328.00 | $ 173,328.00 | $ 83,328.00 | $ 128,328.00 | $ 133,328.00 |
Total Cash Available | $ 235,800.00 | $ 203,328.00 | $ 172,259.76 | $ 231,198.08 | $ 200,143.02 | $ 214,094.64 | $ 233,053.02 |
Cash paid Out | |||||||
Salary Expense | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | $ 83,328.00 | |
Rent Expense | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | $ 3,500.00 | |
Repairs Expense | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | |
Alterations Expense | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | $ 1,500.00 | |
Dry Cleaning Expense | $ 8,514.00 | $ 8,514.00 | $ 8,514.00 | $ 8,514.00 | $ 8,514.00 | $ 8,514.00 | |
Advertising Expense | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | $ 2,000.00 | |
Supplies Expense | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | |
Insurance Expense | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | $ 750.00 | |
Misc. Expense | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | |
Payroll Taxes | $ 8,957.70 | $ 8,957.70 | $ 8,957.70 | $ 8,957.70 | $ 8,957.70 | $ 8,957.70 | |
Legal And Accounting | $ - | $ - | $ - | $ - | $ - | $ - | |
Utilities Expense | $ 1,875.00 | $ 1,875.00 | $ 1,875.00 | $ 1,875.00 | $ 1,875.00 | $ 1,875.00 | |
Bad Debts Expense | $ - | $ - | $ - | $ - | $ - | $ - | |
Interest Expense | $ 1,508.00 | $ 1,501.44 | $ 1,494.82 | $ 1,488.14 | $ 1,481.38 | $ 150.80 | |
Sub total | $ - | ||||||
Loan Payment | $ 2,163.54 | $ 2,163.54 | $ 2,163.54 | $ 2,163.54 | $ 2,163.54 | $ 2,163.54 | |
Capital Purchses | $ 150,800.00 | ||||||
Total Expenditures | $ 150,800.00 | $ 114,396.24 | $ 114,389.68 | $ 114,383.06 | $ 114,376.38 | $ 114,369.62 | $ 113,039.04 |
Total Cash Out | $ 150,800.00 | $ 114,396.24 | $ 114,389.68 | $ 114,383.06 | $ 114,376.38 | $ 114,369.62 | $ 113,039.04 |
Cash Balance | $ 85,000.00 | $ 88,931.76 | $ 57,870.08 | $ 116,815.02 | $ 85,766.64 | $ 99,725.02 | $ 120,013.98 |